Effective dating
Snapshots
Automation
User friendly interface
But CUNY First has effective dates
Many CUNY First tables don’t have effective dates
Almost no tables have effective end dates
Data warehouse creates end dates for effective dated fields
Data warehouse creates effective dates and effective end dates for fields without
Historical static views of CUNY First at specified points in history
IT has this all set up automatically
The reporting instance query
Extraction from tumbleweed
The effective dating
The snapshots
OBIEE web app interface
Abstracts away leftover complexity of datawarehouse
No SQL required
Drag and drop gui